Enterprise Database Systems
Data Visualization in Excel
Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
it_dadvexdj_05_enus
Excel Visualization: Building Column Charts, Bar Charts, & Histograms
it_dadvexdj_02_enus
Excel Visualization: Getting Started with Excel for Data Visualization
it_dadvexdj_01_enus
Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
it_dadvexdj_04_enus
Excel Visualization: Visualizing Data Using Line Charts & Area Charts
it_dadvexdj_03_enus
Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
Lesson Objectives
Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
- discover the key concepts covered in this course
- create a basic box-and-whisker plot to display various descriptive statistics of a variable, such as the mean, median, 25th percentile, and 75th percentile
- add labels to a box-and-whisker plot, create a box-and-whisker plot with two sets of boxes and whiskers grouped based on a category, and perform various formatting operations on this plot
- create a box-and-whisker-plot with separate categories on the x-axis and based on the color of the box, then add lines linking the means for all categories
- create a sunburst chart to visualize data with more than one level of hierarchy
- create a waterfall chart to show the cumulative effect of positive and negative values over a specified period of time to add up to a total final value
- create a Gantt chart out of a basic stacked bar chart
- create band charts to quickly visualize the trend in a line chart
- display the relationship between two variables and understand what kind of model might be most useful to represent that relationship
- create a waffle or KPI chart with a grid of percentages that update based on an index that in turn updates based on the value of a spin button
- summarize the key concepts covered in this course
Overview/Description
Once you grasp how to work with the scope of standard Excel chart types, you can expand into more complex visualizations. For example, you can use box-and-whisker plots to convey a wealth of information about the statistical distribution of a variable and identify outliers in a data series. You can use sunburst charts to visualize hierarchical data with differing levels of detail, waterfall charts to show the cumulative effect of positive and negative values, and Gantt charts to illustrate progress toward a goal involving multiple parallel tasks. Additionally, you can avail of band charts to quickly eyeball the trend in a line chart, scatter plots to uncover the relationship between two variables, and waffle charts to visualize progress towards KPIs. In this course, you'll create all of these charts either via Excel's built-in tools or by building them manually using nifty workarounds.
Once you grasp how to work with the scope of standard Excel chart types, you can expand into more complex visualizations. For example, you can use box-and-whisker plots to convey a wealth of information about the statistical distribution of a variable and identify outliers in a data series. You can use sunburst charts to visualize hierarchical data with differing levels of detail, waterfall charts to show the cumulative effect of positive and negative values, and Gantt charts to illustrate progress toward a goal involving multiple parallel tasks. Additionally, you can avail of band charts to quickly eyeball the trend in a line chart, scatter plots to uncover the relationship between two variables, and waffle charts to visualize progress towards KPIs. In this course, you'll create all of these charts either via Excel's built-in tools or by building them manually using nifty workarounds.
Target
Prerequisites: none
Excel Visualization: Building Column Charts, Bar Charts, & Histograms
Lesson Objectives
Excel Visualization: Building Column Charts, Bar Charts, & Histograms
- discover the key concepts covered in this course
- create various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature
- use 100% stacked column charts to visualize the proportions of separate categories and visualize data using various 3D column charts
- create a basic 3D column chart and illustrate the potential disadvantage of these charts
- describe the difference between a column chart and a bar chart, create a clustered bar chart, and perform various operations, such as sorting on that chart
- customize various aspects of a bar chart, such as the axis configurations, the overlap between the bars, and the size of the bars
- illustrate the use of many different kinds of Excel bar charts, such as stacked, 100% stacked bar charts, and 3D bar charts
- create a histogram to bin a continuous data series, visualize the counts of rows in each bin, and create histograms for normally and non-normally distributed data series
- customize histograms using various options, such as the overflow and underflow bins to truncate the histogram on either side
- summarize the key concepts covered in this course
Overview/Description
Data visualizations in Excel reveal the insights uncovered by your data in easy-to-consume representations. You can identify categorical values, recognize how parts sum up to a whole, see percentages rather than absolute values, discretize continuous variables, and approximate the probability density function of variables. In this course, you'll build charts to uncover all of this information. You'll start by working with column and bar charts. You'll then create and differentiate between clustered and stacked column charts. You'll move on to formatting and customizing bar and column charts before working with 2D and 3D chart types and customizing them in various ways. Lastly, you'll work with histograms, examining how they work, what they're used for, and how to customize them to your needs.
Data visualizations in Excel reveal the insights uncovered by your data in easy-to-consume representations. You can identify categorical values, recognize how parts sum up to a whole, see percentages rather than absolute values, discretize continuous variables, and approximate the probability density function of variables. In this course, you'll build charts to uncover all of this information. You'll start by working with column and bar charts. You'll then create and differentiate between clustered and stacked column charts. You'll move on to formatting and customizing bar and column charts before working with 2D and 3D chart types and customizing them in various ways. Lastly, you'll work with histograms, examining how they work, what they're used for, and how to customize them to your needs.
Target
Prerequisites: none
Excel Visualization: Getting Started with Excel for Data Visualization
Lesson Objectives
Excel Visualization: Getting Started with Excel for Data Visualization
- discover the key concepts covered in this course
- open up Microsoft Excel and read in data from an Excel workbook and a CSV file
- import an Excel file as an XML file and separately import a JSON file into Excel and open it up in the Power Query Editor
- import data from a PDF document and a Microsoft Access database as well as all files from a folder into Excel
- visualize data using built-in Excel charts, explore various column chart types, and create basic and clustered column charts
- customize a clustered column chart, add trendlines and format the chart, then create a basic line chart
- add up/down bars and high/low lines to a line chart, copy and paste a line chart to a new sheet, and format the line chart
- format the background fill, texture, axes, and title of a column chart and line chart and change the position of two charts relative to each other
- summarize the key concepts covered in this course
Overview/Description
Excel charts can be used for a myriad of data visualizations, including categorical data and continuous data, like time-series data. In this course, you'll learn how to bring data into Excel and build and customize various charts. You'll start by importing data from an existing workbook into a new spreadsheet. You'll then import data from CSV and JSON file formats and Microsoft Access database files. Next, you'll use the Power Query editor to perform various operations. Moving on, you'll create column and clustered column charts and perform various formatting operations on the clustered column chart, such as adding data labels, error bars, axis titles, and trendlines. Lastly, you'll create a simple line chart, formatting various aspects, such as the line, background, title, legend, axes, and position of charts relative to each other.
Excel charts can be used for a myriad of data visualizations, including categorical data and continuous data, like time-series data. In this course, you'll learn how to bring data into Excel and build and customize various charts. You'll start by importing data from an existing workbook into a new spreadsheet. You'll then import data from CSV and JSON file formats and Microsoft Access database files. Next, you'll use the Power Query editor to perform various operations. Moving on, you'll create column and clustered column charts and perform various formatting operations on the clustered column chart, such as adding data labels, error bars, axis titles, and trendlines. Lastly, you'll create a simple line chart, formatting various aspects, such as the line, background, title, legend, axes, and position of charts relative to each other.
Target
Prerequisites: none
Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
Lesson Objectives
Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
- discover the key concepts covered in this course
- visualize the trend of a stock's performance based on high, low, and close values over a specific period of time using the Excel High-Low-Close stock chart
- create an Excel Open-High-Low-Close stock chart, also known as a candlestick chart, in order to visualize financial data
- use a radar chart to visualize the multivariate ordinal data and illustrate the advantages and disadvantages of radar charts
- format various aspects of a radar chart's appearance, add individual points to it, and create filled radar charts
- use the treemap visualization to visualize hierarchical categories
- create a pie chart to display a few categories and the proportions that add up to a whole, then explode specific slices in the pie chart
- use the pie-of-pie chart type to create one pie chart with an 'other' category and a second pie chart that expands the fields in that 'other' category
- use the doughnut chart type to display the proportions of various categories when adding up to a whole, then use it to plot composition at a single instant as well as at different points in time
- summarize the key concepts covered in this course
Overview/Description
Data visualization options in Excel are vast. You should choose your visualization type based on the data and what you want to show from it. For example, using High-Low-Close and Open-High-Low-Close charts (also called candlestick charts), you can summarize several stock performance aspects. Excel also lets you build radar charts - great for visualizing multivariate ordinal data, such as ratings or scores, to spot strengths or spikes. In this course, you'll not only learn how to build and customize the charts mentioned, but you'll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. You'll then generate pie-of-pie and bar-of-pie charts, both of which use a secondary visualization to complement a pie chart. Finally, you'll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.
Data visualization options in Excel are vast. You should choose your visualization type based on the data and what you want to show from it. For example, using High-Low-Close and Open-High-Low-Close charts (also called candlestick charts), you can summarize several stock performance aspects. Excel also lets you build radar charts - great for visualizing multivariate ordinal data, such as ratings or scores, to spot strengths or spikes. In this course, you'll not only learn how to build and customize the charts mentioned, but you'll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. You'll then generate pie-of-pie and bar-of-pie charts, both of which use a secondary visualization to complement a pie chart. Finally, you'll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.
Target
Prerequisites: none
Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Lesson Objectives
Excel Visualization: Visualizing Data Using Line Charts & Area Charts
- discover the key concepts covered in this course
- create a basic line chart, experiment with the data label options in a line chart, and change the fill color of the line in a line chart
- illustrate the use of the gradient fill feature, change various aspects of a gradient-filled line chart, and work with radial gradients and linear gradients
- customize various aspects of the line on a line chart, such as the thickness of the line and whether a line is represented using dashes, dots, or both.
- use trendlines to explore the suitability of various kinds of regression models, such as linear regression and polynomial regression via a line chart
- illustrate the use of various features related to trendlines, such as predicting future N periods
- classify the advantages and disadvantages of variants of line charts, such as stacked line charts, 100% stacked line charts, and 3D line charts
- create a basic area chart, illustrate a major disadvantage of an ordinary area chart, then change the opacity of areas in order to overcome this problem
- create and format an area chart, create a stacked area chart, and illustrate the many advantages of stacked area charts over ordinary area charts
- illustrate how a 100% stacked area chart is computed so that there is no overlap in the areas and the proportions of individual categories from a whole can be assessed easily
- create 3D area charts, illustrate the various ways to overcome certain areas being obscured, and create a 3D stacked area chart
- create a 3D area chart and format the back wall, side wall, and floor
- summarize the key concepts covered in this course
Overview/Description
Line charts are possibly the most common type of visualization for time-series data, enabling you to see time trends at a glance. These can be augmented with trendlines, used to visualize time trends in data. Stacked area charts are a powerful type of visualization, combining information about trends over time with information about composition and parts of a whole. In this course, you'll learn how to create and customize all of the visualization types above. You'll begin by exploring the purpose of line charts before moving on to formatting and customizing them. You'll then practice using trendlines to evaluate different regression models on data in a line chart. You'll also customize and format these trendlines. Following this, you'll work with area charts and stacked area charts, examining, in detail, the several types of stacked area charts in Excel and customizing their appearance.
Line charts are possibly the most common type of visualization for time-series data, enabling you to see time trends at a glance. These can be augmented with trendlines, used to visualize time trends in data. Stacked area charts are a powerful type of visualization, combining information about trends over time with information about composition and parts of a whole. In this course, you'll learn how to create and customize all of the visualization types above. You'll begin by exploring the purpose of line charts before moving on to formatting and customizing them. You'll then practice using trendlines to evaluate different regression models on data in a line chart. You'll also customize and format these trendlines. Following this, you'll work with area charts and stacked area charts, examining, in detail, the several types of stacked area charts in Excel and customizing their appearance.
Target
Prerequisites: none
